USE [Construarte]
GO

/****** Object: Table [dbo].[Etapa] Script Date: 31/08/2013 16:39:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Etapa] (
    [EtapaId]      INT            IDENTITY (1, 1) NOT NULL,
    [DescEtapa]    NVARCHAR (150) NULL,
    [PorcAtingida] INT            NULL,
    [ObraId]       INT            NOT NULL,
    CONSTRAINT [FK_Etapa_Obra] FOREIGN KEY ([ObraId]) REFERENCES [dbo].[Obra] ([ObraId]), 
    CONSTRAINT [PK_Etapa] PRIMARY KEY ([EtapaId])
);

